package com.acwer.drools.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.acwer.drools.domain.BenchMark;
import com.acwer.drools.domain.Jbbm20;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Repository
public interface Jbbm20Dao extends BaseMapper<Jbbm20>{
	@Select({ "<script>", 
		"select TOP 6 * from JBBM20 where JBMC LIKE concat('%',#{parm},'%') OR JBBM LIKE concat('%',#{parm},'%') OR PYJM LIKE concat('%',#{parm},'%') order by  length(PYJM),length(JBBM) ,length(JBMC)  ASC" ,"</script>"
		})
	public List<Jbbm20> getJbbm20(String  parm);
}
